CREATE TABLE [dbo].[UserInfo] (
  [Id] int IDENTITY(101200, 1) NOT NULL,
  [UserName] nchar(100) COLLATE Chinese_PRC_CI_AS NULL,
  [Password] nchar(100) COLLATE Chinese_PRC_CI_AS NULL,
  [NickName] nchar(100) COLLATE Chinese_PRC_CI_AS NULL,
  [Address] nchar(100) COLLATE Chinese_PRC_CI_AS NULL,
  CONSTRAINT [PK_UserInfo] PRIMARY KEY CLUSTERED ([Id])
    WITH (
      PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF, STATISTICS_NORECOMPUTE = OFF,
      ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
)
ON [PRIMARY]
GO